﻿-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[usp_get_pending_request_by_name] 
@BizTalkApplication varchar(255),
@BizTalkPortName varchar(255)
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    SELECT ID, Description, EndpointValue, BindingType, TransportType,
		TransportLocation, UDDIContactName, UDDIEmail, UDDIUserType,
		BiztalkApplication, EndpointName, Status, ModifiedBy, Category,
		TargetNamespace, MessageExchangePattern, JaxRPCResponse, 
		ServiceAction, CacheTimeOut, RequestAction, BusinessProvider, ServiceName
	FROM EndPoints
	WHERE BiztalkApplication = @BizTalkApplication and
		EndpointName = @BizTalkPortName
END
